Super Charge Excel by Matt Allington

Author:Matt Allington
Language: eng
Format: epub
Tags: big data;data analysis;data scientist;excel;excel 2016;Excel;Business Intelligence;finance;microsoft;msbi;pivot table;pivottable;powerpivot;sharepoint;spreadsheets;DAX;formulas
Publisher: Holy Macro! Books
Published: 2018-04-06T19:55:02+00:00

Returning a Single Value

VALUES() returns a single-column table of unique values from any column in any table, and this new table of values respects the initial filter context coming from the pivot table. There is another very cool feature of VALUES() that is very powerful: In the special case where VALUES() returns just a single row in the single-column table (i.e., one value), you can refer to this value directly in your formulas.

If you take the example created above, remove CalendarYear from Rows, and put MonthName on Rows instead, you should get the following.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.